Model Table SITE DISCOM INFO

This model dimension represents site distribution information and is based on the IFS Cloud dimension DIM_SITE_DISCOM_INFO. All models that refers to this dimension will have the attributes and hierarchies as described below.

Attributes

Attribute Description (where applicable)
Site DiscomDefined as CODE + ' - ' + DESCRIPTION, i.e. site and its description.
Site Discom BranchBranch
Site Discom Create Order In Rel StateCreate CO in released state
Site Discom Create Order In Rel State DescrCreate CO in released state description
Site Discom Customer Order Disc MethodCustomer order discount method
Site Discom Customer Order Disc Method DescrCustomer order discount method description
Site Discom Customer Order Pricing MethodCustomer order pricing method
Site Discom Customer Order Pricing Method DescrCustomer order pricing method description
Site Discom Disp Cond Customer OrderDisplay condition code on CO
Site Discom Disp Cond Customer Order DescrDisplay condition code on CO description
Site Discom Disp Cond Purchase OrderDisplay condition code on PO
Site Discom Disp Cond Purchase Order DescrDisplay condition code on PO description
Site Discom Purch Comp MethodPurchase component method
Site Discom Purch Comp Method DescriptionPurchase component method description
Site Discom Ship Inventory Location NumberDefault shipment location
Site Discom User PartCa Description OrderUse Part Catalog Description as Description for Sales Part
Site Discom User PartCa Description Order DescrUse PartCat Desc as Desc for Sales Part Description
Site Discom User PartCa Description PurchaseUse Part Catalog Description as Description for Purchase part
Site Discom User PartCa Description Purchase DescrUse PartCat Desc as Desc for Purchase Part Description
Site Discom User Pre Ship Delivery NoteUse two stage picking
Site Discom User Pre Ship Delivery Note DescrUse two stage picking description

USED BY MODEL(S)

Model Name
Crm

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
SITE DISCOM INFODIM_SITE_DISCOM_INFO_TMDIM_SITE_DISCOM_INFO_BIDIM_SITE_DISCOM_INFOOn Line